-
Re: How can I link cells from an excel form to a column in smart sheet?
@LilyWANG Consider using Smartsheet's Data Connector for Excel, which allows you to link Smartsheet and Excel , keeping data in sync. Another option is using third-party tools like Zapier or Microsof…1 · -
Re: Can 2 task sheets be on one dashboard?
Hi @Tricia5w You can use report to consolidate data from multiple sheets and display it in a single dashboard.1 · -
Re: Rolling 30 day formula with specific text
@Timothy Your are welcome @Timothy. Kindly accept the answer and Vote-up. It will help other Smartsheet user like you😀1 · -
Re: Rolling 30 day formula with specific text
@Timothy , No worries! I have another solution for you which you can apply in sheet summary. Please find the below formula & screenshot =COUNTIFS([Today- Scheduled]:[Today- Scheduled], <=30, S…1 · -
Re: =totalfloat() appears to work, but not treated as a number??
Hi @JoshC, You made a mistake in the formula. Please see the updated formula below. =IF([Slack Time]@row > 10, "Green", IF([Slack Time]@row < 1, "Red", "Yellow")) …1 ·